SIR2002                                          11:34:18  04/18/05                                           Page    1
0
1       RUN NAME        RETRIEVE EXPORT
2       TASK NAME       INITIALIZATION
3       NEW FILE        RETRIEVE
4       JOURNAL         OFF
*** REMARK *** Created new database RETRIEVE
5       CASE ID         UNITNO   (A)
*** REMARK *** Begin case definition
6       N OF CASES      15000
7       RECS PER CASE   30
8       MAX INPUT COLS  200
9       RECTYPE COLS    1  2
10      MAX REC TYPES   30
11      MAX REC COUNT   500
12      COMMON VARS       UNITNO   (I*4)         / DOB      (DATE,'DDMMYYYY')
13                      /
*** REMARK *** Common variable list updated
14      TEMP VARS       T0        T1        T2        T3        T4
15                      T5        T6        T7        T8        T9
*** REMARK *** Temporary variable list updated
16      DOCUMENT
17
18
19
20        This data base is the first stage in the development of the new
21       Obstetric Data Bank.  The intention is that it will be
22       used to form the basis for the structure for the new system.  The design
23       is expected to be changed a number of times over the next few
24       months/year, but this is anticipated to be carried out in the light of
25       experience in using the system.
26
27         A major restructure of the data base was undertaken to -
28
29         1. Increase all date fields to DD/MM/YYYY from DD/MM/YY to allow
30            for the year 2000 and the effect it would have
31
32         2. Increase the UNITNO field to 8 digits
33
34         3. Replace all 1 character spaces with 2 characters to allow
35            fields to increase / new fields to be added
36
37         4. Re-arrange fields and data lines to cope with changes above
38
39
40       NB. Except where documented within the individual schemas the changes
41           outlined above apply to ALL schema.
42
43                                          John S. Lemon
44                                           1st May 1996
45
46      TASK NAME       RECORD 1 (PATIENT )  SCHEMA DEFINITION
*** REMARK *** Case definition complete
47
48      RECORD SCHEMA   1  PATIENT
*** REMARK *** Begin record definition
*** REMARK *** Define record type 1
49      DOCUMENT       This record contains those unchanging items about
50                     a woman - her date of birth, place of birth
51                     and maiden name for example.
RETRIEVE EXPORT                                                                                               Page    2
 RECORD 1 (PATIENT )  SCHEMA DEFINITION
52
53      SEQUENCE CHECK  OFF
54      MAX REC COUNT   1
55      DATA LIST       (3)
56                      /1        UNITNO          4 -    11 (I4)
57                      /1        DOB            57 -    64 (DATE'DDMMYYYY')
58                      /1        YOB            61 -    64 (I2)
******** Input columns for variable overlap with another var. (Warning 165 - YOB     )
59                      /3        BSOCLASS        4         (I1)
60                      /2        BLOODGRP       37 -    39 (A3)
61                      /2        HEIGHT         41 -    43 (I2)
62                      /2        HTCLASS        46         (I1)
63      CAT VARS        BLOODGRP  ( 'A+ '
64                                  'A- '
65                                  'B+ '
66                                  'B- '
67                                  'O+ '
68                                  'O- '
69                                  'AB+'
70                                  'AB-'  )/
71      RECODE          HTCLASS   =         HEIGHT
72                      ( LOWEST THRU 154 = 0 )
73                      ( 155 THRU 163 = 0 )
74                      ( 164 THRU HIGHEST = 0 )
75      VAR RANGES      BSOCLASS  (                    1                     9)/
76                      HEIGHT    (                  130                   195)/
77      MISSING VALUES  UNITNO    ( BLANK  )/
78                      DOB       ( BLANK  )/
79                      YOB       ( BLANK  )/
80                      BSOCLASS  ( BLANK  )/
81                      BLOODGRP  ( BLANK  )/
82                      HEIGHT    ( BLANK  )/
83                      HTCLASS   ( BLANK  )/
84      VALUE LABELS    YOB       (1900)' 1900'
85                                (1901)' 1901'
86                                (1902)' 1902'
87                                (1903)' 1903'
88                                (1904)' 1904'
89                                (1905)' 1905'
90                                (1906)' 1906'
91                                (1907)' 1907'
92                                (1908)' 1908'
93                                (1909)' 1909'
94                                (1910)' 1910'
95                                (1911)' 1911'
96                                (1912)' 1912'
97                                (1913)' 1913'
98                                (1914)' 1914'
99                                (1915)' 1915'
100                               (1916)' 1916'
101                               (1917)' 1917'
102                               (1918)' 1918'
103                               (1919)' 1919'
104                               (1920)' 1920'
105                               (1921)' 1921'
106                               (1922)' 1922'
107                               (1923)' 1923'
RETRIEVE EXPORT                                                                                               Page    3
 RECORD 1 (PATIENT )  SCHEMA DEFINITION
108                               (1924)' 1924'
109                               (1925)' 1925'
110                               (1926)' 1926'
111                               (1927)' 1927'
112                               (1928)' 1928'
113                               (1929)' 1929'
114                               (1930)' 1930'
115                               (1931)' 1931'
116                               (1932)' 1932'
117                               (1933)' 1933'
118                               (1934)' 1934'
119                               (1935)' 1935'
120                               (1936)' 1936'
121                               (1937)' 1937'
122                               (1938)' 1938'
123                               (1939)' 1939'
124                               (1940)' 1940'
125                               (1941)' 1941'
126                               (1942)' 1942'
127                               (1943)' 1943'
128                               (1944)' 1944'
129                               (1945)' 1945'
130                               (1946)' 1946'
131                               (1947)' 1947'
132                               (1948)' 1948'
133                               (1949)' 1949'
134                               (1950)' 1950'
135                               (1951)' 1951'
136                               (1952)' 1952'
137                               (1953)' 1953'
138                               (1954)' 1954'
139                               (1955)' 1955'
140                               (1956)' 1956'
141                               (1957)' 1957'
142                               (1958)' 1958'
143                               (1959)' 1959'
144                               (1960)' 1960'
145                               (1961)' 1961'
146                               (1962)' 1962'
147                               (1963)' 1963'
148                               (1964)' 1964'
149                               (1965)' 1965'
150                               (1966)' 1966'
151                               (1967)' 1967'
152                               (1968)' 1968'
153                               (1969)' 1969'
154                               (1970)' 1970'
155                               (1971)' 1971'
156                               (1972)' 1972'
157                               (1973)' 1973'
158                               (1974)' 1974'
159                               (1975)' 1975'
160                               (1976)' 1976'
161                               (1977)' 1977'
162                               (1978)' 1978'
163                               (1979)' 1979'
164                               (1980)' 1980'
RETRIEVE EXPORT                                                                                               Page    4
 RECORD 1 (PATIENT )  SCHEMA DEFINITION
165                               (1981)' 1981'
166                               (1982)' 1982'
167                               (1983)' 1983'
168                               (1984)' 1984'
169                               (1985)' 1985'
170                               (1986)' 1986'
171                               (1987)' 1987'
172                               (1988)' 1988'
173                               (1989)' 1989'
174                               (1990)' 1990'
175                               (1991)' 1991'
176                               (1992)' 1992'
177                               (1993)' 1993'
178                               (1994)' 1994'
179                               (1995)' 1995'
180                               (1996)' 1996'
181                               (1997)' 1997'
182                               (1998)' 1998'
183                               (1999)' 1999'
184                               (2000)' 2000'
185                               (2001)' 2001'
186                               (2002)' 2002'
187                               (2003)' 2003'
188                               (2004)' 2004'
189                               (2005)' 2005'
190                               (2006)' 2006'
191                               (2007)' 2007'
192                               (2008)' 2008'
193                               (2009)' 2009'
194                               (2010)' 2010'
195                               (UNDEFINED)' Undefined'
196                               (BLANK)' Missing' /
197                     BSOCLASS  (1)' I'
198                               (2)' II'
199                               (3)' III non-manual'
200                               (4)' III manual'
201                               (5)' IV'
202                               (6)' V'
203                               (7)' Other'
204                               (8)' Single - widowed'
205                               (9)' Missing'
206                               (UNDEFINED)' Undefined'
207                               (BLANK)' Missing' /
208                     BLOODGRP  ('A+ ')' A+'
209                               ('A- ')' A-'
210                               ('B+ ')' B+'
211                               ('B- ')' B-'
212                               ('O+ ')' O+'
213                               ('O- ')' O-'
214                               ('AB+')' AB+'
215                               ('AB-')' AB-'
216                               (UNDEFINED)' Undefined'
217                               (BLANK)' Missing' /
218                     HTCLASS   (1)' Small'
219                               (2)' Medium'
220                               (3)' Tall'
221                               (UNDEFINED)' Undefined'
RETRIEVE EXPORT                                                                                               Page    5
 RECORD 1 (PATIENT )  SCHEMA DEFINITION
222                               (BLANK)' Missing' /
223     VAR LABELS      UNITNO      ' UNITNO'/
224                     DOB         ' Date of Birth'/
225                     YOB         ' Year of Birth'/
226                     BSOCLASS    ' Father''s Social Class'/
227                     BLOODGRP    ' Blood Group'/
228                     HEIGHT      ' Height in cms'/
229                     HTCLASS     ' Height ( grouped )'/
230     REJECT REC IF   (UNITNO GT 9999999)
231     END SCHEMA
*** REMARK *** Record schema complete
*** REMARK *** Database now at update level 2
*** REMARK *** Record definition complete
*** REMARK *** Schema updated
232     TASK NAME       RECORD 5 (PREGNANC)  SCHEMA DEFINITION
233
234     RECORD SCHEMA   5  PREGNANC
*** REMARK *** Begin record definition
*** REMARK *** Define record type 5
235     DOCUMENT       Details of the first ante-natal/booking visit and thus
236                    some of the  unchanging  items in a pregnancy. Details
237                    for previous medical history etc. are held as
238                    separate record types. When the date of the last
239                    menstrual period is given only as a month LMP to be
240                    assigned  to the 15th day
241
242                     Up to 1975 the following variables have values assigned
243                     as stated:
244                     MCYCLE: A value of 27 means 28
245                                        28       28
246                                        42       29-42
247                                        43       42
248                     NPDAY: A value of 99 means smoker,number not stated.
249                          : 0 means non-smoker.
250                     HBDOB: (Husband's date of birth)computed from date of
251                           visit and age and set at 1st day of year.
252                            i.e.01/01/YYYY.
253        Up to 1975      POSTCODE: For previously Aberdeen "city" residence
254                        code, the postcode has been given as AB01999; for
255                        previous "suburb" codes, the postcode has been given
256                        as AB03999; and for previous "elsewhere" codes,
257                        the postcode has been taken as AB08999.
258
259            To avoid the loss of new records being input DOBOOK was added as a
260           superfluous SORT ID, this means that an accidental duplicate
261           pregnancy number will not cause great problems. This means that
262           DOBOOK will have to exist for all cases and pregnancy records.
263           If the date of booking is missing then the date of last menstrual
264           period is used for date of booking, if this is also missing then
265           date of delivery ( DOSTAGE3 ) is used.
266                                                    5/11/1993
267
268     KEY FIELDS      PREGNO (A)    DOBOOK (A)
269     SEQUENCE CHECK  OFF
270     MAX REC COUNT   25
271     DATA LIST       (6)
272                     /1        UNITNO          4 -    11 (I4)
RETRIEVE EXPORT                                                                                               Page    6
 RECORD 5 (PREGNANC)  SCHEMA DEFINITION
273                     /1        PREGNO         14 -    15 (I1)
274                     /1        DOBOOK         18 -    25 (DATE'DDMMYYYY')
275                     /1        PARITY         36 -    37 (I1)
276                     /1        MSTAT          55 -    56 (A2)
277                     /1        DOMARG         59 -    66 (DATE'DDMMYYYY')
278                     /2        LMP            65 -    73 (DATE'DDMMYYYY')
279                     /3        CERTAIN         4         (A1)
280                     /3        GESTN          10 -    11 (I1)
281                     /3        GCERT          14         (A1)
282                     /3        MCYCLE         17 -    20 (I2)
283                     /3        NPDAY          23 -    24 (I1)
284                     /3        RESID          36         (I1)
285                     /3        HBDOB          39 -    46 (DATE'DDMMYYYY')
286                     /6        HSOCLASS        4         (I1)
287     CAT VARS        MSTAT     ( 'S '
288                                 'M '
289                                 'W '
290                                 'D '
291                                 'SP'
292                                 'CO'  )/
293                     CERTAIN   ( 'C'
294                                 'A'
295                                 'U'  )/
296                     GCERT     ( 'C'
297                                 'A'
298                                 'U'  )/
299     RECODE          PAROUS    =         PARITY
300                     ( 0 = 0 )
301                     ( 1 THRU HIGHEST = 0 )
302                     ( ELSE = UNDEFINED )
303     MISSING VALUES  UNITNO    ( BLANK  )/
304                     PREGNO    ( BLANK  )/
305                     DOBOOK    ( BLANK  )/
306                     PARITY    ( BLANK  )/
307                     MSTAT     ( BLANK  )/
308                     DOMARG    ( BLANK  )/
309                     LMP       ( BLANK  )/
310                     CERTAIN   ( BLANK  )/
311                     GESTN     ( BLANK  )/
312                     GCERT     ( BLANK  )/
313                     MCYCLE    ( BLANK  )/
314                     NPDAY     (                    -9
315                                 BLANK  )/
316                     RESID     ( BLANK  )/
317                     HBDOB     ( BLANK  )/
318                     HSOCLASS  ( BLANK  )/
319     VALUE LABELS    MSTAT     ('S ')' Single'
320                               ('M ')' Married'
321                               ('W ')' Widowed'
322                               ('D ')' Divorced'
323                               ('SP')' Separated'
324                               ('CO')' Co-habiting'
325                               (UNDEFINED)' Undefined'
326                               (BLANK)' Missing' /
327                     CERTAIN   ('C')' Certain'
328                               ('A')' Approx'
329                               ('U')' Uncertain'
RETRIEVE EXPORT                                                                                               Page    7
 RECORD 5 (PREGNANC)  SCHEMA DEFINITION
330                               (UNDEFINED)' Undefined'
331                               (BLANK)' Missing' /
332                     GCERT     ('C')' Certain'
333                               ('A')' Approx'
334                               ('U')' Uncertain'
335                               (UNDEFINED)' Undefined'
336                               (BLANK)' Missing' /
337                     RESID     (0)' Unknown'
338                               (1)' Aberdeen City District'
339                               (2)' Grampian Region (except Aberdeen)'
340                               (3)' Other'
341                               (UNDEFINED)' Undefined'
342                               (BLANK)' Missing' /
343                     HSOCLASS  (1)' I'
344                               (2)' II'
345                               (3)' III non-manual'
346                               (4)' III manual'
347                               (5)' IV'
348                               (6)' V'
349                               (7)' Other'
350                               (8)' Single - widowed'
351                               (9)' Missing'
352                               (UNDEFINED)' Undefined'
353                               (BLANK)' Missing' /
354     VAR LABELS      UNITNO      ' UNITNO'/
355                     PREGNO      ' Pregnancy Number'/
356                     DOBOOK      ' Date of Booking'/
357                     PARITY      ' Parity Number'/
358                     MSTAT       ' Marital Status'/
359                     DOMARG      ' Date of current marriage'/
360                     LMP         ' Start Date of Last Menstrual Period'/
361                     CERTAIN     ' Degree of Accuracy of LMP Date'/
362                     GESTN       ' Gestation Period at Delivery'/
363                     GCERT       ' Degree of Accuracy of Gestation'/
364                     MCYCLE      ' Usual Menstrual Cycle ( days )'/
365                     NPDAY       ' Number of Cigarettes Smoked per Day'/
366                     RESID       ' Place of Residence'/
367                     HBDOB       ' Husband''s ( Father''s ) Date of Birth'/
368                     HSOCLASS    ' Husband''s - partners Social Class'/
369     REJECT REC IF   (UNITNO GT 9999999)
370     REJECT REC IF   (((DOBOOK-DOB)LT 3650)OR((DOBOOK-DOB)GT 20075))
371     REJECT REC IF   (((LMP-DOB)LT 3650)OR((LMP-DOB)GT 20075))
372     REJECT REC IF   (((DOMARG-DOB)LT 3650)OR((DOMARG-DOB)GT 20075))
373     END SCHEMA
*** REMARK *** Record schema complete
*** REMARK *** Database now at update level 3
*** REMARK *** Record definition complete
*** REMARK *** Schema updated
374     TASK NAME       RECORD 6 (ANTENATA)  SCHEMA DEFINITION
375
376     RECORD SCHEMA   6  ANTENATA
*** REMARK *** Begin record definition
*** REMARK *** Define record type 6
377     DOCUMENT       Records details of each antenatal visit, whether as
378                    an inpatient or outpatient.
379
380     KEY FIELDS      PREGNO (A)    ANDATE (A)
RETRIEVE EXPORT                                                                                               Page    8
 RECORD 6 (ANTENATA)  SCHEMA DEFINITION
381     SEQUENCE CHECK  OFF
382     MAX REC COUNT   375
383     DATA LIST       (1)
384                     /1        UNITNO          4 -    11 (I4)
385                     /1        PREGNO         14 -    15 (I1)
386                     /1        ANDATE         18 -    25 (DATE'DDMMYYYY')
387                     /1        WEIGHT         28 -    32 (F1)
388                     /1        SYSTBP         35 -    37 (I2)
389                     /1        DIASBP         40 -    42 (I2)
390                     /1        UALB           45         (A1)
391                     /1        USUG           48         (A1)
392                     /1        PTYPE          51         (A1)
393                     /1        WEEKS          54 -    55 (I1)
394                     /1        VTYPE          58         (A1)
395                     /1        SFHT           61 -    62 (I1)
396     CAT VARS        UALB      ( 'N'
397                                 'A'  )/
398                     USUG      ( 'N'
399                                 'A'  )/
400                     PTYPE     ( 'I'
401                                 'O'  )/
402                     VTYPE     ( 'G'
403                                 'S'
404                                 'M'
405                                 'U'
406                                 'O'  )/
407     VAR RANGES      WEIGHT    (                   30                   180)/
408                     SYSTBP    (                   50                   250)/
409                     DIASBP    (                   20                   150)/
410                     WEEKS     (                    6                    44)/
411                     SFHT      (                    5                    60)/
412     MISSING VALUES  UNITNO    ( BLANK  )/
413                     PREGNO    ( BLANK  )/
414                     ANDATE    ( BLANK  )/
415                     WEIGHT    ( BLANK  )/
416                     SYSTBP    ( BLANK  )/
417                     DIASBP    ( BLANK  )/
418                     UALB      ( BLANK  )/
419                     USUG      ( BLANK  )/
420                     PTYPE     ( BLANK  )/
421                     WEEKS     ( BLANK  )/
422                     VTYPE     ( BLANK  )/
423                     SFHT      ( BLANK  )/
424     VALUE LABELS    UALB      ('N')' Normal'
425                               ('A')' Abnormal'
426                               (UNDEFINED)' Undefined'
427                               (BLANK)' Missing' /
428                     USUG      ('N')' Normal'
429                               ('A')' Abnormal'
430                               (UNDEFINED)' Undefined'
431                               (BLANK)' Missing' /
432                     PTYPE     ('I')' Inpatient'
433                               ('O')' Outpatient'
434                               (UNDEFINED)' Undefined'
435                               (BLANK)' Missing' /
436                     VTYPE     ('G')' GP'
437                               ('S')' Specialist'
RETRIEVE EXPORT                                                                                               Page    9
 RECORD 6 (ANTENATA)  SCHEMA DEFINITION
438                               ('M')' Midwife'
439                               ('U')' Unknown'
440                               ('O')' Other'
441                               (UNDEFINED)' Undefined'
442                               (BLANK)' Missing' /
443     VAR LABELS      UNITNO      ' UNITNO'/
444                     ANDATE      ' Date of Antenatal Visit'/
445                     WEIGHT      ' Patient''s Weight (in kgs)'/
446                     SYSTBP      ' Systolic Blood Pressure'/
447                     DIASBP      ' Diastolic Blood Pressure'/
448                     UALB        ' Urine Albumin'/
449                     USUG        ' Urine Sugar'/
450                     PTYPE       ' Type of Patient'/
451                     WEEKS       ' Actual Weeks ( Calculated )'/
452                     VTYPE       ' Type of Visit'/
453                     SFHT        ' Symphisis - Fundal height ( cms )'/
454     REJECT REC IF   (UNITNO GT 9999999)
455     REJECT REC IF   (((ANDATE-DOB)LT 3650)OR((ANDATE-DOB)GT 20075))
456     REJECT REC IF   (DIASBP GT SYSTBP)
457     END SCHEMA
*** REMARK *** Record schema complete
*** REMARK *** Database now at update level 4
*** REMARK *** Record definition complete
*** REMARK *** Schema updated
458     TASK NAME       RECORD 17 (DELIVERY)  SCHEMA DEFINITION
459
460     RECORD SCHEMA   17  DELIVERY
*** REMARK *** Begin record definition
*** REMARK *** Define record type 17
461     DOCUMENT       This record is a summary of labour and delivery
462                    including date and time of  the stages of labour
463                    either spontaneous or induced
464
465     KEY FIELDS      PREGNO (A)    DOSTAGE3 (A)
466     SEQUENCE CHECK  OFF
467     MAX REC COUNT   15
468     DATA LIST       (6)
469                     /1        UNITNO          4 -    11 (I4)
470                     /1        PREGNO         14 -    15 (I1)
471                     /5        DOSTAGE3       18 -    25 (DATE'DDMMYYYY')
472                     /5        YEARDEL        22 -    25 (I2)
******** Input columns for variable overlap with another var. (Warning 165 - YEARDEL )
473                     /1        AGEDEL         64 -    65 (I1)
474                     /1        DOUTCOME       71 -    72 (I1)
475                     /1        LABTYPE        52         (A1)
476     CAT VARS        LABTYPE   ( 'E'
477                                 'S'
478                                 'I'  )/
479     VAR RANGES      YEARDEL   (                 1948                  2031)/
480                     AGEDEL    (                   10                    50)/
481                     DOUTCOME  (                   -1                    11)/
482     MISSING VALUES  UNITNO    ( BLANK  )/
483                     PREGNO    ( BLANK  )/
484                     DOSTAGE3  ( BLANK  )/
485                     YEARDEL   ( BLANK  )/
486                     AGEDEL    ( BLANK  )/
487                     DOUTCOME  ( BLANK  )/
RETRIEVE EXPORT                                                                                               Page   10
 RECORD 17 (DELIVERY)  SCHEMA DEFINITION
488                     LABTYPE   ( BLANK  )/
489     VALUE LABELS    YEARDEL   (1948)' 1948'
490                               (1949)' 1949'
491                               (1950)' 1950'
492                               (1951)' 1951'
493                               (1952)' 1952'
494                               (1953)' 1953'
495                               (1954)' 1954'
496                               (1955)' 1955'
497                               (1956)' 1956'
498                               (1957)' 1957'
499                               (1958)' 1958'
500                               (1959)' 1959'
501                               (1960)' 1960'
502                               (1961)' 1961'
503                               (1962)' 1962'
504                               (1963)' 1963'
505                               (1964)' 1964'
506                               (1965)' 1965'
507                               (1966)' 1966'
508                               (1967)' 1967'
509                               (1968)' 1968'
510                               (1969)' 1969'
511                               (1970)' 1970'
512                               (1971)' 1971'
513                               (1972)' 1972'
514                               (1973)' 1973'
515                               (1974)' 1974'
516                               (1975)' 1975'
517                               (1976)' 1976'
518                               (1977)' 1977'
519                               (1978)' 1978'
520                               (1979)' 1979'
521                               (1980)' 1980'
522                               (1981)' 1981'
523                               (1982)' 1982'
524                               (1983)' 1983'
525                               (1984)' 1984'
526                               (1985)' 1985'
527                               (1986)' 1986'
528                               (1987)' 1987'
529                               (1988)' 1988'
530                               (1989)' 1989'
531                               (1990)' 1990'
532                               (1991)' 1991'
533                               (1992)' 1992'
534                               (1993)' 1993'
535                               (1994)' 1994'
536                               (1995)' 1995'
537                               (1996)' 1996'
538                               (1997)' 1997'
539                               (1998)' 1998'
540                               (1999)' 1999'
541                               (2000)' 2000'
542                               (2001)' 2001'
543                               (2002)' 2002'
544                               (2003)' 2003'
RETRIEVE EXPORT                                                                                               Page   11
 RECORD 17 (DELIVERY)  SCHEMA DEFINITION
545                               (2004)' 2004'
546                               (2005)' 2005'
547                               (2006)' 2006'
548                               (2007)' 2007'
549                               (2008)' 2008'
550                               (2009)' 2009'
551                               (2010)' 2010'
552                               (2011)' 2011'
553                               (2012)' 2012'
554                               (2013)' 2013'
555                               (2014)' 2014'
556                               (2015)' 2015'
557                               (2016)' 2016'
558                               (2017)' 2017'
559                               (2018)' 2018'
560                               (2019)' 2019'
561                               (2020)' 2020'
562                               (2021)' 2021'
563                               (2022)' 2022'
564                               (2023)' 2023'
565                               (2024)' 2024'
566                               (2025)' 2025'
567                               (2026)' 2026'
568                               (2027)' 2027'
569                               (2028)' 2028'
570                               (2029)' 2029'
571                               (2030)' 2030'
572                               (2031)' 2031'
573                               (UNDEFINED)' Undefined'
574                               (BLANK)' Missing' /
575                     DOUTCOME  (-1)' Unknown'
576                               (0)' Singleton (unk)'
577                               (1)' Livebirth'
578                               (2)' Stillbirth'
579                               (3)' LB - LB'
580                               (4)' LB - SB'
581                               (5)' SB - SB'
582                               (6)' LB - Abn'
583                               (7)' SB - Abn'
584                               (8)' Abn - Abn'
585                               (9)' Twin (unk)'
586                               (10)' Abn'
587                               (11)' Multiple'
588                               (UNDEFINED)' Undefined'
589                               (BLANK)' Missing' /
590                     LABTYPE   ('E')' Elective CS'
591                               ('S')' Spontaneous'
592                               ('I')' Induced'
593                               (UNDEFINED)' Undefined'
594                               (BLANK)' Missing' /
595     VAR LABELS      UNITNO      ' UNITNO'/
596                     PREGNO      ' Pregnancy number'/
597                     DOSTAGE3    ' Date of stage 3 labour (delivery)'/
598                     YEARDEL     ' Year of Delivery'/
599                     AGEDEL      ' Age at delivery-complete years'/
600                     DOUTCOME    ' Outcome of Delivery'/
601                     LABTYPE     ' Type of Labour'/
RETRIEVE EXPORT                                                                                               Page   12
 RECORD 17 (DELIVERY)  SCHEMA DEFINITION
602     REJECT REC IF   (UNITNO GT 9999999)
603     REJECT REC IF   (((DOSTAGE3-DOB)LT 3650)OR((DOSTAGE3-DOB)GT 20075))
604     END SCHEMA
*** REMARK *** Record schema complete
*** REMARK *** Database now at update level 5
*** REMARK *** Record definition complete
*** REMARK *** Schema updated
605     TASK NAME       RECORD 21 (BABY    )  SCHEMA DEFINITION
606
607     RECORD SCHEMA   21  BABY
*** REMARK *** Begin record definition
*** REMARK *** Define record type 21
608     DOCUMENT       This record contains details for each baby
609                    delivered including type of delivery
610                    and outcome.
611
612     KEY FIELDS      PREGNO (A)    BDATE (A)     BORDER (A)
613     SEQUENCE CHECK  OFF
614     MAX REC COUNT   15
615     DATA LIST       (3)
616                     /1        UNITNO          4 -    11 (I4)
617                     /1        PREGNO         14 -    15 (I1)
618                     /1        BORDER         32         (I1)
619                     /1        BDATE          35 -    42 (DATE'DDMMYYYY')
620                     /1        DELTYPE        51         (I1)
621                     /1        BPRES          54         (I1)
622                     /1        BSEX           57         (A1)
623                     /1        BABYWT         60 -    63 (I2)
624                     /2        CHLENGTH        4 -     5 (I1)
625                     /2        CRLENGTH        8 -     9 (I1)
626                     /2        BABYOFC        12 -    15 (F1)
627                     /2        APGAR1         18 -    19 (I1)
628                     /2        APGAR5         22 -    23 (I1)
629                     /2        BOUTCOME       26         (I1)
630     CAT VARS        BSEX      ( 'M'
631                                 'F'
632                                 'U'  )/
633     VAR RANGES      BORDER    (                    1                     7)/
634                     DELTYPE   (                    1                     9)/
635                     BPRES     (                    1                     9)/
636                     BABYWT    (                  100                  6000)/
637                     CHLENGTH  (                   15                    70)/
638                     CRLENGTH  (                   10                    50)/
639                     BABYOFC   (                   10                    50)/
640                     APGAR1    (                    0                    10)/
641                     APGAR5    (                    0                    10)/
642                     BOUTCOME  (                    1                     7)/
643     MISSING VALUES  UNITNO    ( BLANK  )/
644                     PREGNO    ( BLANK  )/
645                     BORDER    ( BLANK  )/
646                     BDATE     ( BLANK  )/
647                     DELTYPE   ( BLANK  )/
648                     BPRES     ( BLANK  )/
649                     BSEX      ( BLANK  )/
650                     BABYWT    ( BLANK  )/
651                     CHLENGTH  ( BLANK  )/
652                     CRLENGTH  ( BLANK  )/
RETRIEVE EXPORT                                                                                               Page   13
 RECORD 21 (BABY    )  SCHEMA DEFINITION
653                     BABYOFC   ( BLANK  )/
654                     APGAR1    ( BLANK  )/
655                     APGAR5    ( BLANK  )/
656                     BOUTCOME  ( BLANK  )/
657     VALUE LABELS    DELTYPE   (1)' SVD'
658                               (2)' Forceps'
659                               (3)' Kiellands Forceps'
660                               (4)' Vacuum Extraction'
661                               (5)' Assisted Breech'
662                               (6)' Breech Extraction'
663                               (7)' Caesarean Section'
664                               (8)' Destructive'
665                               (9)' Other'
666                               (UNDEFINED)' Undefined'
667                               (BLANK)' Missing' /
668                     BPRES     (1)' OA'
669                               (2)' OP'
670                               (3)' OT,OL'
671                               (4)' Breech'
672                               (5)' Face,Brow'
673                               (6)' Shoulder,Transverse'
674                               (7)' Cord'
675                               (8)' Compound'
676                               (9)' Other'
677                               (UNDEFINED)' Undefined'
678                               (BLANK)' Missing' /
679                     BSEX      ('M')' Male'
680                               ('F')' Female'
681                               ('U')' Unknown'
682                               (UNDEFINED)' Undefined'
683                               (BLANK)' Missing' /
684                     BOUTCOME  (1)' Livebirth'
685                               (2)' Stillbirth'
686                               (3)' 1st Day Death'
687                               (4)' 1st Week Death (excl 1st day)'
688                               (5)' Other Neonatal Death'
689                               (6)' Spont Abortion'
690                               (7)' Missed Abortion'
691                               (UNDEFINED)' Undefined'
692                               (BLANK)' Missing' /
693     VAR LABELS      UNITNO      ' UNITNO'/
694                     PREGNO      ' Pregnancy number'/
695                     BORDER      ' Baby birth order'/
696                     BDATE       ' Baby''s date of birth'/
697                     DELTYPE     ' Type of delivery'/
698                     BPRES       ' Baby presentation at delivery'/
699                     BSEX        ' Sex of baby'/
700                     BABYWT      ' Weight of baby'/
701                     CHLENGTH    ' Crown-heel length'/
702                     CRLENGTH    ' Crown-rump length'/
703                     BABYOFC     ' Occipito-frontal circumference'/
704                     APGAR1      ' Apgar score at 1 minute'/
705                     APGAR5      ' Apgar score at 5 minutes'/
706                     BOUTCOME    ' Outcome of pregnancy'/
707     REJECT REC IF   (UNITNO GT 9999999)
708     REJECT REC IF   (((BDATE-DOB)LT 3650)OR((BDATE-DOB)GT 20075))
709     END SCHEMA
RETRIEVE EXPORT                                                                                               Page   14
 RECORD 21 (BABY    )  SCHEMA DEFINITION
*** REMARK *** Record schema complete
*** REMARK *** Database now at update level 6
*** REMARK *** Record definition complete
*** REMARK *** Schema updated
710     STRING LENGTH   20
711     TASK NAME       IMPORT
712     IMPORT          47147
RETRIEVE EXPORT                                                                                               Page   15
 IMPORT
*** REMARK *** Start import
*** REMARK *** Import successfully completed
*** REMARK *** Imported cases   5682
*** REMARK *** Imported records 47147
712
RETRIEVE EXPORT                                                                                               Page   16
Message summary
Error  165 - Input columns for variable overlap with another var.
